﻿CREATE TABLE [dbo].[Person] (
    [PersonID]             UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]          DATETIME         NOT NULL,
    [CreatedBy]            UNIQUEIDENTIFIER NOT NULL,
    [ModifiedDate]         DATETIME         NOT NULL,
    [ModifiedBy]           UNIQUEIDENTIFIER NOT NULL,
    [Deleted]              BIT              NOT NULL,
    [GenderID]             UNIQUEIDENTIFIER NOT NULL,
    [RaceID]               UNIQUEIDENTIFIER NOT NULL,
    [ResidentialAddressID] UNIQUEIDENTIFIER NOT NULL,
    [ContactDetailID]      UNIQUEIDENTIFIER NOT NULL,
    [IdentityTypeID]       UNIQUEIDENTIFIER NOT NULL,
    [FirstName]            VARCHAR (24)     NOT NULL,
    [MiddleName]           VARCHAR (24)     NOT NULL,
    [Surname]              VARCHAR (24)     NOT NULL,
    [Initials]             VARCHAR (6)      NOT NULL,
    [IdentityNumber]       VARCHAR (24)     NOT NULL,
    [DateOfBirth]          DATETIME         NOT NULL,
    [Age]                  INT              NOT NULL
);

